From 7900d5fe93a5ba7d2bcf670f84f79708183096c7 Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Fri, 24 Oct 2025 05:50:05 +0000 Subject: [PATCH] Ignore rows necessary to complete conversion, after nesting cleanup State of conversion ignores after commit: b95f8d343c --- conversion/load_biography.sql | 3 + conversion/load_community_membership.sql | 61 + conversion/load_follow_arrival.m4 | 2510 ++++++++++++++++++++++ conversion/load_follow_to_follows.sql | 112 +- 4 files changed, 2685 insertions(+), 1 deletion(-) diff --git a/conversion/load_biography.sql b/conversion/load_biography.sql index a0b522c..c985748 100644 --- a/conversion/load_biography.sql +++ b/conversion/load_biography.sql @@ -87,6 +87,9 @@ INSERT INTO biography_data( -- Discard b_departdateerror , b_departtype FROM clean.biography + + WHERE b_animid <> 'KAZ' -- Problem #11 + ; ANALYZE biography_data; diff --git a/conversion/load_community_membership.sql b/conversion/load_community_membership.sql index 52abc2c..2493532 100644 --- a/conversion/load_community_membership.sql +++ b/conversion/load_community_membership.sql @@ -37,6 +37,67 @@ INSERT INTO comm_membs ( , cm_start_source , cm_end_source FROM community_membership + +WHERE +-- Problem #13 +-- select b.b_animid, cm.cm_start_date +-- from clean.community_membership as cm +-- join clean.biography as b +-- on (b.b_animid = cm.cm_b_animid) +-- where b.b_birthgroup is distinct from cm.cm_cl_community_id +-- and cm.cm_start_date < b.b_entrydate +-- order by b.b_animid, cm.cm_start_date; + NOT ((cm_b_animid = 'CT' + AND cm_start_date = '1976-07-01') + OR (cm_b_animid = 'CT' + AND cm_start_date = '1980-01-01') + OR (cm_b_animid = 'ECO' + AND cm_start_date = '2003-09-15') + OR (cm_b_animid = 'EOW' + AND cm_start_date = '2003-09-15') + OR (cm_b_animid = 'EZA' + AND cm_start_date = '2003-12-01') + OR (cm_b_animid = 'FLWB1' + AND cm_start_date = '2017-05-14') + OR (cm_b_animid = 'IMA' + AND cm_start_date = '2005-02-15') + OR (cm_b_animid = 'KAZ' + AND cm_start_date = '2006-01-01') + OR (cm_b_animid = 'SG' + AND cm_start_date = '1976-07-01') + OR (cm_b_animid = 'SG' + AND cm_start_date = '1980-01-01') + OR (cm_b_animid = 'SP' + AND cm_start_date = '1965-01-01') + OR (cm_b_animid = 'SY' + AND cm_start_date = '1969-07-01') + OR (cm_b_animid = 'WB' + AND cm_start_date = '1973-06-15')) +-- Problem #14 +-- select b.b_animid, cm.cm_end_date +-- from clean.community_membership as cm +-- join clean.biography as b +-- on (b.b_animid = cm.cm_b_animid) +-- where cm.cm_end_date > b.b_departdate +-- order by b.b_animid, cm.cm_end_date; +AND NOT ((cm_b_animid = 'MG' + AND cm_end_date = '1977-12-31') + OR (cm_b_animid = 'RO' + AND cm_end_date = '1977-12-31') + OR (cm_b_animid = 'WD' + AND cm_end_date = '1977-12-31')) +-- Problem #55 +-- select b.b_animid, b.b_birthdate, cm.cm_start_date +-- from clean.community_membership as cm +-- join clean.biography as b +-- on (b.b_animid = cm.cm_b_animid) +-- where cm.cm_start_date < b.b_birthdate +-- order by b.b_animid, cm.cm_start_date; +AND NOT (cm_b_animid = 'FN' + AND cm_start_date = '1981-03-17') +-- Problem #11 +AND NOT cm_b_animid = 'KAZ' + -- Get a consistent ID generation ORDER BY cm_start_date, cm_end_date, cm_b_animid, cm_cl_community_id; diff --git a/conversion/load_follow_arrival.m4 b/conversion/load_follow_arrival.m4 index 0cbdb74..bca3ffd 100644 --- a/conversion/load_follow_arrival.m4 +++ b/conversion/load_follow_arrival.m4 @@ -47,6 +47,2516 @@ BEGIN FOR this_fa IN SELECT * FROM clean.follow_arrival + WHERE EXISTS -- Problem #43 + (SELECT 1 + FROM follows + WHERE follows.focal = follow_arrival.fa_fol_b_focal_animid + AND follows.date = follow_arrival.fa_fol_date) + AND NOT -- problem #41 + ((fa_fol_date = '1975-05-15' + AND fa_fol_b_focal_animid = 'SW' + AND fa_b_arr_animid = 'SA') + OR (fa_fol_date = '1975-05-15' + AND fa_fol_b_focal_animid = 'SW' + AND fa_b_arr_animid = 'SW') + OR (fa_fol_date = '1982-08-31' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'MM') + OR (fa_fol_date = '1988-10-26' + AND fa_fol_b_focal_animid = 'PF' + AND fa_b_arr_animid = 'GL') + OR (fa_fol_date = '2006-03-14' + AND fa_fol_b_focal_animid = 'SW' + AND fa_b_arr_animid = 'TZN') + OR (fa_fol_date = '2006-03-14' + AND fa_fol_b_focal_animid = 'SW' + AND fa_b_arr_animid = 'TZN') + OR (fa_fol_date = '2006-03-14' + AND fa_fol_b_focal_animid = 'SW' + AND fa_b_arr_animid = 'TZN') + OR (fa_fol_date = '2006-03-14' + AND fa_fol_b_focal_animid = 'SW' + AND fa_b_arr_animid = 'TZN') + OR (fa_fol_date = '2009-01-11' + AND fa_fol_b_focal_animid = 'FO' + AND fa_b_arr_animid = 'TB') + OR (fa_fol_date = '2011-12-26' + AND fa_fol_b_focal_animid = 'GLD' + AND fa_b_arr_animid = 'GA') + OR (fa_fol_date = '2011-12-26' + AND fa_fol_b_focal_animid = 'GLD' + AND fa_b_arr_animid = 'GGL')) + AND NOT -- Problem #44 + -- select follow_arrival.fa_fol_date + -- , follow_arrival.fa_fol_b_focal_animid + -- , follow_arrival.fa_b_arr_animid + -- from clean.follow_arrival + -- join clean.biography + -- on (biography.b_animid = follow_arrival.fa_b_arr_animid) + -- where biography.b_entrydate > follow_arrival.fa_fol_date + -- order by biography.b_animid, follow_arrival.fa_fol_date; + ((fa_fol_date = '1973-01-04' + AND fa_fol_b_focal_animid = 'MK' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-01-09' + AND fa_fol_b_focal_animid = 'HM' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-01-17' + AND fa_fol_b_focal_animid = 'FG' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-01-17' + AND fa_fol_b_focal_animid = 'FG' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-01-26' + AND fa_fol_b_focal_animid = 'FB' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-01-29' + AND fa_fol_b_focal_animid = 'JJ' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-01-29' + AND fa_fol_b_focal_animid = 'JJ' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-01-29' + AND fa_fol_b_focal_animid = 'JJ' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-02-01' + AND fa_fol_b_focal_animid = 'EV' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-02-03' + AND fa_fol_b_focal_animid = 'SW' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-02-04' + AND fa_fol_b_focal_animid = 'AT' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-02-05' + AND fa_fol_b_focal_animid = 'SW' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-02-07' + AND fa_fol_b_focal_animid = 'EV' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-02-11' + AND fa_fol_b_focal_animid = 'SW' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-02-14' + AND fa_fol_b_focal_animid = 'NV' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-02-16' + AND fa_fol_b_focal_animid = 'AL' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-02-19' + AND fa_fol_b_focal_animid = 'EV' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-02-19' + AND fa_fol_b_focal_animid = 'EV' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-02-19' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-02-19' + AND fa_fol_b_focal_animid = 'ST' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-02-19' + AND fa_fol_b_focal_animid = 'ST' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-02-20' + AND fa_fol_b_focal_animid = 'AT' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-02-26' + AND fa_fol_b_focal_animid = 'AT' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-02-27' + AND fa_fol_b_focal_animid = 'FG' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-02-27' + AND fa_fol_b_focal_animid = 'AT' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-02-27' + AND fa_fol_b_focal_animid = 'FG' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-03-01' + AND fa_fol_b_focal_animid = 'AT' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-03-04' + AND fa_fol_b_focal_animid = 'ST' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-03-05' + AND fa_fol_b_focal_animid = 'HM' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-03-05' + AND fa_fol_b_focal_animid = 'HM' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-03-05' + AND fa_fol_b_focal_animid = 'MF' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-03-05' + AND fa_fol_b_focal_animid = 'MF' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-03-05' + AND fa_fol_b_focal_animid = 'MU' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-03-07' + AND fa_fol_b_focal_animid = 'AT' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-03-10' + AND fa_fol_b_focal_animid = 'AT' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-03-10' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-03-20' + AND fa_fol_b_focal_animid = 'AT' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-03-23' + AND fa_fol_b_focal_animid = 'GG' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-03-23' + AND fa_fol_b_focal_animid = 'GG' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-03-23' + AND fa_fol_b_focal_animid = 'GG' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-03-29' + AND fa_fol_b_focal_animid = 'AT' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-04-07' + AND fa_fol_b_focal_animid = 'HM' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-04-08' + AND fa_fol_b_focal_animid = 'WK' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-04-19' + AND fa_fol_b_focal_animid = 'EV' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-04-19' + AND fa_fol_b_focal_animid = 'PL' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-04-19' + AND fa_fol_b_focal_animid = 'PS' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-04-19' + AND fa_fol_b_focal_animid = 'PS' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-04-20' + AND fa_fol_b_focal_animid = 'FB' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-04-20' + AND fa_fol_b_focal_animid = 'FB' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-04-24' + AND fa_fol_b_focal_animid = 'MK' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-04-25' + AND fa_fol_b_focal_animid = 'HG' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-04-25' + AND fa_fol_b_focal_animid = 'FG' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-04-25' + AND fa_fol_b_focal_animid = 'HG' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-04-25' + AND fa_fol_b_focal_animid = 'MK' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-01' + AND fa_fol_b_focal_animid = 'AT' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-02' + AND fa_fol_b_focal_animid = 'FB' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-03' + AND fa_fol_b_focal_animid = 'FB' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-03' + AND fa_fol_b_focal_animid = 'FB' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-03' + AND fa_fol_b_focal_animid = 'FB' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-03' + AND fa_fol_b_focal_animid = 'FB' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-03' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-03' + AND fa_fol_b_focal_animid = 'NV' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-07' + AND fa_fol_b_focal_animid = 'SW' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-10' + AND fa_fol_b_focal_animid = 'FG' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-11' + AND fa_fol_b_focal_animid = 'FB' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-11' + AND fa_fol_b_focal_animid = 'FB' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-14' + AND fa_fol_b_focal_animid = 'EV' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-16' + AND fa_fol_b_focal_animid = 'EV' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-16' + AND fa_fol_b_focal_animid = 'HG' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-17' + AND fa_fol_b_focal_animid = 'AT' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-17' + AND fa_fol_b_focal_animid = 'GG' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-17' + AND fa_fol_b_focal_animid = 'GG' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-17' + AND fa_fol_b_focal_animid = 'ML' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-17' + AND fa_fol_b_focal_animid = 'MU' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-19' + AND fa_fol_b_focal_animid = 'AT' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-19' + AND fa_fol_b_focal_animid = 'MK' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-20' + AND fa_fol_b_focal_animid = 'MF' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-22' + AND fa_fol_b_focal_animid = 'AT' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-22' + AND fa_fol_b_focal_animid = 'JJ' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-23' + AND fa_fol_b_focal_animid = 'EV' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-25' + AND fa_fol_b_focal_animid = 'FB' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-25' + AND fa_fol_b_focal_animid = 'MK' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-26' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-26' + AND fa_fol_b_focal_animid = 'GG' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-27' + AND fa_fol_b_focal_animid = 'FG' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-27' + AND fa_fol_b_focal_animid = 'FG' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-27' + AND fa_fol_b_focal_animid = 'GG' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-28' + AND fa_fol_b_focal_animid = 'GG' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-28' + AND fa_fol_b_focal_animid = 'GG' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-28' + AND fa_fol_b_focal_animid = 'MK' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-30' + AND fa_fol_b_focal_animid = 'HM' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-31' + AND fa_fol_b_focal_animid = 'FB' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-31' + AND fa_fol_b_focal_animid = 'HM' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-31' + AND fa_fol_b_focal_animid = 'MF' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-06-01' + AND fa_fol_b_focal_animid = 'AT' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-06-06' + AND fa_fol_b_focal_animid = 'FG' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-06-06' + AND fa_fol_b_focal_animid = 'FG' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-06-06' + AND fa_fol_b_focal_animid = 'ML' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-06-06' + AND fa_fol_b_focal_animid = 'SW' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-06-06' + AND fa_fol_b_focal_animid = 'SW' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-06-10' + AND fa_fol_b_focal_animid = 'AL' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-06-10' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-06-10' + AND fa_fol_b_focal_animid = 'HG' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-06-10' + AND fa_fol_b_focal_animid = 'HG' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-06-11' + AND fa_fol_b_focal_animid = 'AL' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-06-14' + AND fa_fol_b_focal_animid = 'MK' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-06-14' + AND fa_fol_b_focal_animid = 'AL' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-06-14' + AND fa_fol_b_focal_animid = 'EV' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-06-14' + AND fa_fol_b_focal_animid = 'EV' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-06-14' + AND fa_fol_b_focal_animid = 'ST' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-06-14' + AND fa_fol_b_focal_animid = 'ST' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-06-15' + AND fa_fol_b_focal_animid = 'FB' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-06-15' + AND fa_fol_b_focal_animid = 'FB' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-06-15' + AND fa_fol_b_focal_animid = 'PL' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-06-17' + AND fa_fol_b_focal_animid = 'FG' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-06-17' + AND fa_fol_b_focal_animid = 'FG' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-06-17' + AND fa_fol_b_focal_animid = 'SH' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-06-21' + AND fa_fol_b_focal_animid = 'AL' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-06-21' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-06-21' + AND fa_fol_b_focal_animid = 'FG' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-06-21' + AND fa_fol_b_focal_animid = 'FG' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-06-21' + AND fa_fol_b_focal_animid = 'FG' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '2005-12-02' + AND fa_fol_b_focal_animid = 'FD' + AND fa_b_arr_animid = 'BRZ') + OR (fa_fol_date = '1980-10-23' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'CT') + OR (fa_fol_date = '1980-10-23' + AND fa_fol_b_focal_animid = 'ST' + AND fa_b_arr_animid = 'CT') + OR (fa_fol_date = '1980-10-23' + AND fa_fol_b_focal_animid = 'ST' + AND fa_b_arr_animid = 'CT') + OR (fa_fol_date = '1980-10-23' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'CT') + OR (fa_fol_date = '1980-10-23' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'CT') + OR (fa_fol_date = '1980-10-24' + AND fa_fol_b_focal_animid = 'ST' + AND fa_b_arr_animid = 'CT') + OR (fa_fol_date = '1981-05-29' + AND fa_fol_b_focal_animid = 'AT' + AND fa_b_arr_animid = 'CT') + OR (fa_fol_date = '1981-05-29' + AND fa_fol_b_focal_animid = 'AT' + AND fa_b_arr_animid = 'CT') + OR (fa_fol_date = '1981-10-12' + AND fa_fol_b_focal_animid = 'ST' + AND fa_b_arr_animid = 'CT') + OR (fa_fol_date = '1981-10-12' + AND fa_fol_b_focal_animid = 'ST' + AND fa_b_arr_animid = 'CT') + OR (fa_fol_date = '1981-10-15' + AND fa_fol_b_focal_animid = 'MF' + AND fa_b_arr_animid = 'CT') + OR (fa_fol_date = '1981-10-15' + AND fa_fol_b_focal_animid = 'MF' + AND fa_b_arr_animid = 'CT') + OR (fa_fol_date = '1981-10-16' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'CT') + OR (fa_fol_date = '1982-01-11' + AND fa_fol_b_focal_animid = 'WK' + AND fa_b_arr_animid = 'CT') + OR (fa_fol_date = '1982-07-27' + AND fa_fol_b_focal_animid = 'EV' + AND fa_b_arr_animid = 'CT') + OR (fa_fol_date = '1982-07-27' + AND fa_fol_b_focal_animid = 'EV' + AND fa_b_arr_animid = 'CT') + OR (fa_fol_date = '1982-10-02' + AND fa_fol_b_focal_animid = 'JJ' + AND fa_b_arr_animid = 'CT') + OR (fa_fol_date = '1982-10-02' + AND fa_fol_b_focal_animid = 'JJ' + AND fa_b_arr_animid = 'CT') + OR (fa_fol_date = '1982-10-02' + AND fa_fol_b_focal_animid = 'JJ' + AND fa_b_arr_animid = 'CT') + OR (fa_fol_date = '1982-10-02' + AND fa_fol_b_focal_animid = 'JJ' + AND fa_b_arr_animid = 'CT') + OR (fa_fol_date = '1982-10-02' + AND fa_fol_b_focal_animid = 'JJ' + AND fa_b_arr_animid = 'CT') + OR (fa_fol_date = '1982-10-11' + AND fa_fol_b_focal_animid = 'AT' + AND fa_b_arr_animid = 'CT') + OR (fa_fol_date = '1984-05-03' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'CT') + OR (fa_fol_date = '1984-05-03' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'CT') + OR (fa_fol_date = '2004-06-13' + AND fa_fol_b_focal_animid = 'RUM' + AND fa_b_arr_animid = 'EDE') + OR (fa_fol_date = '1974-05-30' + AND fa_fol_b_focal_animid = 'ST' + AND fa_b_arr_animid = 'GD1') + OR (fa_fol_date = '2011-07-10' + AND fa_fol_b_focal_animid = 'SAM' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-07-10' + AND fa_fol_b_focal_animid = 'SAM' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '1989-07-17' + AND fa_fol_b_focal_animid = 'WL' + AND fa_b_arr_animid = 'KN') + OR (fa_fol_date = '1989-07-17' + AND fa_fol_b_focal_animid = 'WL' + AND fa_b_arr_animid = 'KN') + OR (fa_fol_date = '1989-07-17' + AND fa_fol_b_focal_animid = 'WL' + AND fa_b_arr_animid = 'KN') + OR (fa_fol_date = '1989-07-17' + AND fa_fol_b_focal_animid = 'WL' + AND fa_b_arr_animid = 'KN') + OR (fa_fol_date = '1989-07-17' + AND fa_fol_b_focal_animid = 'WL' + AND fa_b_arr_animid = 'KN') + OR (fa_fol_date = '1989-07-17' + AND fa_fol_b_focal_animid = 'WL' + AND fa_b_arr_animid = 'KN') + OR (fa_fol_date = '2006-01-09' + AND fa_fol_b_focal_animid = 'EDG' + AND fa_b_arr_animid = 'LOS') + OR (fa_fol_date = '2006-01-09' + AND fa_fol_b_focal_animid = 'EDG' + AND fa_b_arr_animid = 'LOS') + OR (fa_fol_date = '2006-01-11' + AND fa_fol_b_focal_animid = 'MGA' + AND fa_b_arr_animid = 'LOS') + OR (fa_fol_date = '2006-01-12' + AND fa_fol_b_focal_animid = 'RUD' + AND fa_b_arr_animid = 'LOS') + OR (fa_fol_date = '2004-02-14' + AND fa_fol_b_focal_animid = 'SL' + AND fa_b_arr_animid = 'MAM') + OR (fa_fol_date = '2004-02-17' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'MAM') + OR (fa_fol_date = '2004-02-17' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'MAM') + OR (fa_fol_date = '2004-02-17' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'MAM') + OR (fa_fol_date = '2004-02-18' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'MAM') + OR (fa_fol_date = '2004-02-18' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'MAM') + OR (fa_fol_date = '2004-02-18' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'MAM') + OR (fa_fol_date = '2004-02-18' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'MAM') + OR (fa_fol_date = '2004-02-18' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'MAM') + OR (fa_fol_date = '2004-02-18' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'MAM') + OR (fa_fol_date = '2004-02-18' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'MAM') + OR (fa_fol_date = '2004-02-19' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'MAM') + OR (fa_fol_date = '2004-02-19' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'MAM') + OR (fa_fol_date = '2004-02-20' + AND fa_fol_b_focal_animid = 'FR' + AND fa_b_arr_animid = 'MAM') + OR (fa_fol_date = '2004-02-21' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'MAM') + OR (fa_fol_date = '2004-02-21' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'MAM') + OR (fa_fol_date = '2004-02-21' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'MAM') + OR (fa_fol_date = '2004-02-25' + AND fa_fol_b_focal_animid = 'AO' + AND fa_b_arr_animid = 'MAM') + OR (fa_fol_date = '2008-10-16' + AND fa_fol_b_focal_animid = 'PX' + AND fa_b_arr_animid = 'SAF') + OR (fa_fol_date = '2001-06-18' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'SAM') + OR (fa_fol_date = '2001-06-18' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'SAM') + OR (fa_fol_date = '1980-10-23' + AND fa_fol_b_focal_animid = 'ST' + AND fa_b_arr_animid = 'SG') + OR (fa_fol_date = '1980-10-23' + AND fa_fol_b_focal_animid = 'ST' + AND fa_b_arr_animid = 'SG') + OR (fa_fol_date = '1980-10-23' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'SG') + OR (fa_fol_date = '1980-10-23' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'SG') + OR (fa_fol_date = '1980-10-23' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'SG') + OR (fa_fol_date = '1980-10-24' + AND fa_fol_b_focal_animid = 'ST' + AND fa_b_arr_animid = 'SG') + OR (fa_fol_date = '1981-05-29' + AND fa_fol_b_focal_animid = 'AT' + AND fa_b_arr_animid = 'SG') + OR (fa_fol_date = '1981-05-29' + AND fa_fol_b_focal_animid = 'AT' + AND fa_b_arr_animid = 'SG') + OR (fa_fol_date = '1981-10-12' + AND fa_fol_b_focal_animid = 'ST' + AND fa_b_arr_animid = 'SG') + OR (fa_fol_date = '1981-10-12' + AND fa_fol_b_focal_animid = 'ST' + AND fa_b_arr_animid = 'SG') + OR (fa_fol_date = '1981-10-15' + AND fa_fol_b_focal_animid = 'MF' + AND fa_b_arr_animid = 'SG') + OR (fa_fol_date = '1981-10-15' + AND fa_fol_b_focal_animid = 'MF' + AND fa_b_arr_animid = 'SG') + OR (fa_fol_date = '1981-10-16' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'SG') + OR (fa_fol_date = '1982-01-11' + AND fa_fol_b_focal_animid = 'WK' + AND fa_b_arr_animid = 'SG') + OR (fa_fol_date = '1982-07-27' + AND fa_fol_b_focal_animid = 'EV' + AND fa_b_arr_animid = 'SG') + OR (fa_fol_date = '1982-07-27' + AND fa_fol_b_focal_animid = 'EV' + AND fa_b_arr_animid = 'SG') + OR (fa_fol_date = '1982-10-02' + AND fa_fol_b_focal_animid = 'JJ' + AND fa_b_arr_animid = 'SG') + OR (fa_fol_date = '1982-10-02' + AND fa_fol_b_focal_animid = 'JJ' + AND fa_b_arr_animid = 'SG') + OR (fa_fol_date = '1982-10-02' + AND fa_fol_b_focal_animid = 'JJ' + AND fa_b_arr_animid = 'SG') + OR (fa_fol_date = '1982-10-02' + AND fa_fol_b_focal_animid = 'JJ' + AND fa_b_arr_animid = 'SG') + OR (fa_fol_date = '1982-10-02' + AND fa_fol_b_focal_animid = 'JJ' + AND fa_b_arr_animid = 'SG') + OR (fa_fol_date = '1982-10-11' + AND fa_fol_b_focal_animid = 'AT' + AND fa_b_arr_animid = 'SG') + OR (fa_fol_date = '1984-05-03' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'SG') + OR (fa_fol_date = '1984-05-03' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'SG') + OR (fa_fol_date = '2004-08-26' + AND fa_fol_b_focal_animid = 'WL' + AND fa_b_arr_animid = 'SHA') + OR (fa_fol_date = '2004-08-26' + AND fa_fol_b_focal_animid = 'WL' + AND fa_b_arr_animid = 'SHA') + OR (fa_fol_date = '2004-08-26' + AND fa_fol_b_focal_animid = 'WL' + AND fa_b_arr_animid = 'SHA') + OR (fa_fol_date = '2004-08-26' + AND fa_fol_b_focal_animid = 'WL' + AND fa_b_arr_animid = 'SHA') + OR (fa_fol_date = '2004-08-26' + AND fa_fol_b_focal_animid = 'WL' + AND fa_b_arr_animid = 'SHA') + OR (fa_fol_date = '1992-09-02' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'SN1') + OR (fa_fol_date = '1992-09-03' + AND fa_fol_b_focal_animid = 'AL' + AND fa_b_arr_animid = 'SN1') + OR (fa_fol_date = '2012-10-07' + AND fa_fol_b_focal_animid = 'FN' + AND fa_b_arr_animid = 'TAR') + OR (fa_fol_date = '2012-10-07' + AND fa_fol_b_focal_animid = 'FN' + AND fa_b_arr_animid = 'TAR') + OR (fa_fol_date = '2012-10-07' + AND fa_fol_b_focal_animid = 'FN' + AND fa_b_arr_animid = 'TAR') + OR (fa_fol_date = '2016-06-19' + AND fa_fol_b_focal_animid = 'MGF' + AND fa_b_arr_animid = 'VANB1')) + AND NOT -- Problem #46 + -- select follow_arrival.fa_fol_date + -- , follow_arrival.fa_fol_b_focal_animid + -- , follow_arrival.fa_b_arr_animid + -- from clean.follow_arrival + -- join clean.biography + -- on (biography.b_animid = follow_arrival.fa_b_arr_animid) + -- where biography.b_sex <> 'F' + -- and follow_arrival.fa_type_of_cycle <> 'n/a' + -- order by follow_arrival.fa_fol_date + -- , follow_arrival.fa_fol_b_focal_animid + -- , follow_arrival.fa_b_arr_animid; + -- Consistent error message + ((fa_fol_date = '1973-01-18' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'MGM') + OR (fa_fol_date = '1973-06-28' + AND fa_fol_b_focal_animid = 'ST' + AND fa_b_arr_animid = 'MK') + OR (fa_fol_date = '1973-08-21' + AND fa_fol_b_focal_animid = 'PL' + AND fa_b_arr_animid = 'MGM') + OR (fa_fol_date = '1984-03-11' + AND fa_fol_b_focal_animid = 'JJ' + AND fa_b_arr_animid = 'SPB1') + OR (fa_fol_date = '1984-03-11' + AND fa_fol_b_focal_animid = 'JJ' + AND fa_b_arr_animid = 'SPB1') + OR (fa_fol_date = '1984-03-11' + AND fa_fol_b_focal_animid = 'JJ' + AND fa_b_arr_animid = 'SPB1') + OR (fa_fol_date = '1984-03-11' + AND fa_fol_b_focal_animid = 'JJ' + AND fa_b_arr_animid = 'SPB1') + OR (fa_fol_date = '1988-06-02' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-06-02' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-06-02' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-06-02' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-06-02' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-06-02' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-06-04' + AND fa_fol_b_focal_animid = 'PF' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-06-21' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-06-21' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-06-21' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-08-01' + AND fa_fol_b_focal_animid = 'DB' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-08-01' + AND fa_fol_b_focal_animid = 'WN' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-08-01' + AND fa_fol_b_focal_animid = 'WN' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-08-08' + AND fa_fol_b_focal_animid = 'AL' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-08-08' + AND fa_fol_b_focal_animid = 'FD' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-09-24' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-09-24' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-09-24' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-10-03' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-10-03' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-10-03' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-10-03' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-10-03' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-10-11' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-10-11' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-10-12' + AND fa_fol_b_focal_animid = 'AL' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-10-22' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-10-22' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-10-22' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-10-24' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-10-27' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-10-30' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-10-30' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-10-30' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-10-30' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-11-04' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-11-04' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-11-04' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-11-04' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-11-04' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-11-04' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-11-05' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-11-05' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-11-05' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-11-05' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-11-05' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-11-05' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-11-06' + AND fa_fol_b_focal_animid = 'PF' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-11-06' + AND fa_fol_b_focal_animid = 'PF' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-11-08' + AND fa_fol_b_focal_animid = 'PF' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-11-09' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-11-11' + AND fa_fol_b_focal_animid = 'PF' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-11-14' + AND fa_fol_b_focal_animid = 'EV' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '2000-04-26' + AND fa_fol_b_focal_animid = 'JF' + AND fa_b_arr_animid = 'KIG') + OR (fa_fol_date = '2000-05-01' + AND fa_fol_b_focal_animid = 'BE' + AND fa_b_arr_animid = 'KIG') + OR (fa_fol_date = '2000-05-02' + AND fa_fol_b_focal_animid = 'FR' + AND fa_b_arr_animid = 'KIG') + OR (fa_fol_date = '2000-05-16' + AND fa_fol_b_focal_animid = 'KS' + AND fa_b_arr_animid = 'KIG') + OR (fa_fol_date = '2000-05-28' + AND fa_fol_b_focal_animid = 'GL' + AND fa_b_arr_animid = 'KIG') + OR (fa_fol_date = '2000-05-28' + AND fa_fol_b_focal_animid = 'GL' + AND fa_b_arr_animid = 'KIG') + OR (fa_fol_date = '2000-06-01' + AND fa_fol_b_focal_animid = 'AO' + AND fa_b_arr_animid = 'KIG') + OR (fa_fol_date = '2000-06-01' + AND fa_fol_b_focal_animid = 'AO' + AND fa_b_arr_animid = 'KIG') + OR (fa_fol_date = '2000-06-08' + AND fa_fol_b_focal_animid = 'TB' + AND fa_b_arr_animid = 'KIG') + OR (fa_fol_date = '2000-06-23' + AND fa_fol_b_focal_animid = 'SA' + AND fa_b_arr_animid = 'KIG') + OR (fa_fol_date = '2001-12-08' + AND fa_fol_b_focal_animid = 'KS' + AND fa_b_arr_animid = 'FO') + OR (fa_fol_date = '2007-01-02' + AND fa_fol_b_focal_animid = 'FR' + AND fa_b_arr_animid = 'GL') + OR (fa_fol_date = '2007-05-17' + AND fa_fol_b_focal_animid = 'KON' + AND fa_b_arr_animid = 'BIMB1') + OR (fa_fol_date = '2007-05-18' + AND fa_fol_b_focal_animid = 'BIM' + AND fa_b_arr_animid = 'BIMB1') + OR (fa_fol_date = '2007-09-13' + AND fa_fol_b_focal_animid = 'SA' + AND fa_b_arr_animid = 'SIB1') + OR (fa_fol_date = '2007-09-24' + AND fa_fol_b_focal_animid = 'SI' + AND fa_b_arr_animid = 'SIB1') + OR (fa_fol_date = '2007-09-25' + AND fa_fol_b_focal_animid = 'FD' + AND fa_b_arr_animid = 'SIB1') + OR (fa_fol_date = '2007-09-25' + AND fa_fol_b_focal_animid = 'FD' + AND fa_b_arr_animid = 'SIB1') + OR (fa_fol_date = '2007-09-25' + AND fa_fol_b_focal_animid = 'FD' + AND fa_b_arr_animid = 'SIB1') + OR (fa_fol_date = '2007-09-26' + AND fa_fol_b_focal_animid = 'NAS' + AND fa_b_arr_animid = 'SIB1') + OR (fa_fol_date = '2007-09-26' + AND fa_fol_b_focal_animid = 'NAS' + AND fa_b_arr_animid = 'SIB1') + OR (fa_fol_date = '2007-09-27' + AND fa_fol_b_focal_animid = 'AO' + AND fa_b_arr_animid = 'SIB1') + OR (fa_fol_date = '2007-09-27' + AND fa_fol_b_focal_animid = 'AO' + AND fa_b_arr_animid = 'SIB1') + OR (fa_fol_date = '2007-09-27' + AND fa_fol_b_focal_animid = 'AO' + AND fa_b_arr_animid = 'SIB1') + OR (fa_fol_date = '2007-09-27' + AND fa_fol_b_focal_animid = 'AO' + AND fa_b_arr_animid = 'SIB1') + OR (fa_fol_date = '2007-09-27' + AND fa_fol_b_focal_animid = 'AO' + AND fa_b_arr_animid = 'SIB1') + OR (fa_fol_date = '2007-09-29' + AND fa_fol_b_focal_animid = 'SW' + AND fa_b_arr_animid = 'SIB1') + OR (fa_fol_date = '2007-09-30' + AND fa_fol_b_focal_animid = 'EDG' + AND fa_b_arr_animid = 'LON') + OR (fa_fol_date = '2007-09-30' + AND fa_fol_b_focal_animid = 'SN' + AND fa_b_arr_animid = 'SIB1') + OR (fa_fol_date = '2007-09-30' + AND fa_fol_b_focal_animid = 'SN' + AND fa_b_arr_animid = 'SIB1') + OR (fa_fol_date = '2007-10-01' + AND fa_fol_b_focal_animid = 'SI' + AND fa_b_arr_animid = 'SIB1') + OR (fa_fol_date = '2007-10-02' + AND fa_fol_b_focal_animid = 'FR' + AND fa_b_arr_animid = 'SIB1') + OR (fa_fol_date = '2007-10-03' + AND fa_fol_b_focal_animid = 'GA' + AND fa_b_arr_animid = 'SIB1') + OR (fa_fol_date = '2007-10-03' + AND fa_fol_b_focal_animid = 'GA' + AND fa_b_arr_animid = 'SIB1') + OR (fa_fol_date = '2007-10-03' + AND fa_fol_b_focal_animid = 'GA' + AND fa_b_arr_animid = 'SIB1') + OR (fa_fol_date = '2007-10-03' + AND fa_fol_b_focal_animid = 'GA' + AND fa_b_arr_animid = 'SIB1') + OR (fa_fol_date = '2007-10-04' + AND fa_fol_b_focal_animid = 'MAK' + AND fa_b_arr_animid = 'SIB1') + OR (fa_fol_date = '2007-10-06' + AND fa_fol_b_focal_animid = 'FD' + AND fa_b_arr_animid = 'SIB1') + OR (fa_fol_date = '2007-10-06' + AND fa_fol_b_focal_animid = 'FD' + AND fa_b_arr_animid = 'SIB1') + OR (fa_fol_date = '2007-10-06' + AND fa_fol_b_focal_animid = 'FD' + AND fa_b_arr_animid = 'SIB1') + OR (fa_fol_date = '2007-10-08' + AND fa_fol_b_focal_animid = 'SL' + AND fa_b_arr_animid = 'SIB1') + OR (fa_fol_date = '2007-10-09' + AND fa_fol_b_focal_animid = 'SA' + AND fa_b_arr_animid = 'SIB1') + OR (fa_fol_date = '2007-10-09' + AND fa_fol_b_focal_animid = 'SA' + AND fa_b_arr_animid = 'SIB1') + OR (fa_fol_date = '2007-10-10' + AND fa_fol_b_focal_animid = 'SW' + AND fa_b_arr_animid = 'SIB1') + OR (fa_fol_date = '2008-03-12' + AND fa_fol_b_focal_animid = 'EDG' + AND fa_b_arr_animid = 'EDG') + OR (fa_fol_date = '2008-03-12' + AND fa_fol_b_focal_animid = 'EDG' + AND fa_b_arr_animid = 'EDG') + OR (fa_fol_date = '2008-03-12' + AND fa_fol_b_focal_animid = 'EDG' + AND fa_b_arr_animid = 'RUD') + OR (fa_fol_date = '2008-03-12' + AND fa_fol_b_focal_animid = 'EDG' + AND fa_b_arr_animid = 'RUD') + OR (fa_fol_date = '2009-06-11' + AND fa_fol_b_focal_animid = 'FE' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-06-11' + AND fa_fol_b_focal_animid = 'FE' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-06-11' + AND fa_fol_b_focal_animid = 'FE' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-06-24' + AND fa_fol_b_focal_animid = 'FN' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-06-24' + AND fa_fol_b_focal_animid = 'FN' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-06-26' + AND fa_fol_b_focal_animid = 'FR' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-06-26' + AND fa_fol_b_focal_animid = 'FR' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-07-14' + AND fa_fol_b_focal_animid = 'WL' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-07-14' + AND fa_fol_b_focal_animid = 'WL' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-07-17' + AND fa_fol_b_focal_animid = 'AO' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-07-17' + AND fa_fol_b_focal_animid = 'AO' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-07-17' + AND fa_fol_b_focal_animid = 'AO' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-07-17' + AND fa_fol_b_focal_animid = 'AO' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-07-20' + AND fa_fol_b_focal_animid = 'SW' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-07-20' + AND fa_fol_b_focal_animid = 'SW' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-07-24' + AND fa_fol_b_focal_animid = 'ZS' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-07-24' + AND fa_fol_b_focal_animid = 'ZS' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-07-27' + AND fa_fol_b_focal_animid = 'DL' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-07-27' + AND fa_fol_b_focal_animid = 'DL' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-07-27' + AND fa_fol_b_focal_animid = 'DL' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-07-27' + AND fa_fol_b_focal_animid = 'DL' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-07-29' + AND fa_fol_b_focal_animid = 'FE' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-07-30' + AND fa_fol_b_focal_animid = 'TN' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-08-12' + AND fa_fol_b_focal_animid = 'KS' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-08-13' + AND fa_fol_b_focal_animid = 'SL' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-08-13' + AND fa_fol_b_focal_animid = 'SL' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-08-18' + AND fa_fol_b_focal_animid = 'FR' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-08-28' + AND fa_fol_b_focal_animid = 'TB' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-09-01' + AND fa_fol_b_focal_animid = 'FE' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-09-01' + AND fa_fol_b_focal_animid = 'FE' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-09-02' + AND fa_fol_b_focal_animid = 'FD' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-09-02' + AND fa_fol_b_focal_animid = 'FD' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-09-11' + AND fa_fol_b_focal_animid = 'SL' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-09-16' + AND fa_fol_b_focal_animid = 'FN' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-09-16' + AND fa_fol_b_focal_animid = 'FN' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-09-16' + AND fa_fol_b_focal_animid = 'FN' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-09-18' + AND fa_fol_b_focal_animid = 'AO' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-10-07' + AND fa_fol_b_focal_animid = 'FO' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2010-11-05' + AND fa_fol_b_focal_animid = 'SA' + AND fa_b_arr_animid = 'SL') + OR (fa_fol_date = '2011-07-12' + AND fa_fol_b_focal_animid = 'AO' + AND fa_b_arr_animid = 'TZB1') + OR (fa_fol_date = '2011-07-12' + AND fa_fol_b_focal_animid = 'TZ' + AND fa_b_arr_animid = 'TZB1') + OR (fa_fol_date = '2012-04-03' + AND fa_fol_b_focal_animid = 'FND' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '2012-10-30' + AND fa_fol_b_focal_animid = 'SW' + AND fa_b_arr_animid = 'TZN') + OR (fa_fol_date = '2015-07-17' + AND fa_fol_b_focal_animid = 'FN' + AND fa_b_arr_animid = 'IMAB2') + OR (fa_fol_date = '2016-06-19' + AND fa_fol_b_focal_animid = 'MGF' + AND fa_b_arr_animid = 'VANB1') + OR (fa_fol_date = '2016-06-28' + AND fa_fol_b_focal_animid = 'BAH' + AND fa_b_arr_animid = 'TZB3') + OR (fa_fol_date = '2016-06-28' + AND fa_fol_b_focal_animid = 'BAH' + AND fa_b_arr_animid = 'TZB3') + OR (fa_fol_date = '2016-06-30' + AND fa_fol_b_focal_animid = 'TG' + AND fa_b_arr_animid = 'TZB3') + OR (fa_fol_date = '2016-06-30' + AND fa_fol_b_focal_animid = 'TG' + AND fa_b_arr_animid = 'TZB3') + OR (fa_fol_date = '2016-07-01' + AND fa_fol_b_focal_animid = 'TG' + AND fa_b_arr_animid = 'TZB3') + OR (fa_fol_date = '2016-07-01' + AND fa_fol_b_focal_animid = 'TG' + AND fa_b_arr_animid = 'TZB3') + OR (fa_fol_date = '2016-07-01' + AND fa_fol_b_focal_animid = 'TG' + AND fa_b_arr_animid = 'TZB3') + OR (fa_fol_date = '2016-07-01' + AND fa_fol_b_focal_animid = 'TG' + AND fa_b_arr_animid = 'TZB3') + OR (fa_fol_date = '2016-07-02' + AND fa_fol_b_focal_animid = 'TG' + AND fa_b_arr_animid = 'TZB3') + OR (fa_fol_date = '2016-07-03' + AND fa_fol_b_focal_animid = 'TG' + AND fa_b_arr_animid = 'TZB3') + OR (fa_fol_date = '2016-07-03' + AND fa_fol_b_focal_animid = 'TG' + AND fa_b_arr_animid = 'TZB3') + OR (fa_fol_date = '2016-07-04' + AND fa_fol_b_focal_animid = 'TG' + AND fa_b_arr_animid = 'TZB3') + OR (fa_fol_date = '2016-07-04' + AND fa_fol_b_focal_animid = 'TG' + AND fa_b_arr_animid = 'TZB3') + OR (fa_fol_date = '2016-07-14' + AND fa_fol_b_focal_animid = 'NAS' + AND fa_b_arr_animid = 'TZB3') + OR (fa_fol_date = '2016-08-01' + AND fa_fol_b_focal_animid = 'FN' + AND fa_b_arr_animid = 'TZB3') + OR (fa_fol_date = '2016-08-01' + AND fa_fol_b_focal_animid = 'FN' + AND fa_b_arr_animid = 'TZB3')) + AND NOT -- Problem #47 + -- select follow_arrival.fa_fol_date + -- , follow_arrival.fa_fol_b_focal_animid + -- , follow_arrival.fa_b_arr_animid + -- from clean.follow_arrival + -- join clean.biography + -- on (biography.b_animid = follow_arrival.fa_b_arr_animid) + -- where biography.b_sex = 'F' + -- and follow_arrival.fa_type_of_cycle = 'U' + -- and biography.b_birthdate + -- < (follow_arrival.fa_fol_date + -- - '5 years'::INTERVAL + -- ) + -- order by follow_arrival.fa_fol_date + -- , follow_arrival.fa_fol_b_focal_animid + -- , follow_arrival.fa_b_arr_animid; + ((fa_fol_date = '1973-10-15' + AND fa_fol_b_focal_animid = 'ML' + AND fa_b_arr_animid = 'LO') + OR (fa_fol_date = '2016-10-09' + AND fa_fol_b_focal_animid = 'TOM' + AND fa_b_arr_animid = 'FIC') + OR (fa_fol_date = '2016-10-09' + AND fa_fol_b_focal_animid = 'TOM' + AND fa_b_arr_animid = 'FIC') + OR (fa_fol_date = '2016-10-11' + AND fa_fol_b_focal_animid = 'FU' + AND fa_b_arr_animid = 'ESP') + OR (fa_fol_date = '2016-10-11' + AND fa_fol_b_focal_animid = 'FU' + AND fa_b_arr_animid = 'ESP') + OR (fa_fol_date = '2016-10-11' + AND fa_fol_b_focal_animid = 'FU' + AND fa_b_arr_animid = 'ESP') + OR (fa_fol_date = '2016-10-21' + AND fa_fol_b_focal_animid = 'GIM' + AND fa_b_arr_animid = 'FIC') + OR (fa_fol_date = '2016-10-21' + AND fa_fol_b_focal_animid = 'GIM' + AND fa_b_arr_animid = 'FIC') + OR (fa_fol_date = '2016-10-23' + AND fa_fol_b_focal_animid = 'NUR' + AND fa_b_arr_animid = 'FIC') + OR (fa_fol_date = '2016-10-23' + AND fa_fol_b_focal_animid = 'NUR' + AND fa_b_arr_animid = 'FIC') + OR (fa_fol_date = '2016-10-23' + AND fa_fol_b_focal_animid = 'NUR' + AND fa_b_arr_animid = 'FIC') + OR (fa_fol_date = '2016-10-23' + AND fa_fol_b_focal_animid = 'NUR' + AND fa_b_arr_animid = 'FIC') + OR (fa_fol_date = '2016-10-25' + AND fa_fol_b_focal_animid = 'TZ' + AND fa_b_arr_animid = 'FIC') + OR (fa_fol_date = '2016-10-25' + AND fa_fol_b_focal_animid = 'TZ' + AND fa_b_arr_animid = 'FIC') + OR (fa_fol_date = '2016-10-25' + AND fa_fol_b_focal_animid = 'TZ' + AND fa_b_arr_animid = 'FIC') + OR (fa_fol_date = '2016-10-25' + AND fa_fol_b_focal_animid = 'TZ' + AND fa_b_arr_animid = 'FIC')) + AND NOT -- Problem #48 + -- select follow_arrival.fa_fol_date + -- , follow_arrival.fa_fol_b_focal_animid + -- , follow_arrival.fa_b_arr_animid + -- from clean.follow_arrival + -- join clean.biography + -- on (biography.b_animid = follow_arrival.fa_b_arr_animid) + -- where biography.b_departdate < follow_arrival.fa_fol_date + -- order by biography.b_animid, follow_arrival.fa_fol_date; + ((fa_fol_date = '2013-10-12' + AND fa_fol_b_focal_animid = 'FU' + AND fa_b_arr_animid = 'AO') + OR (fa_fol_date = '2014-01-09' + AND fa_fol_b_focal_animid = 'GA' + AND fa_b_arr_animid = 'AO') + OR (fa_fol_date = '2014-09-29' + AND fa_fol_b_focal_animid = 'EOW' + AND fa_b_arr_animid = 'AO') + OR (fa_fol_date = '2014-09-29' + AND fa_fol_b_focal_animid = 'EOW' + AND fa_b_arr_animid = 'AO') + OR (fa_fol_date = '2014-11-28' + AND fa_fol_b_focal_animid = 'DL' + AND fa_b_arr_animid = 'AO') + OR (fa_fol_date = '2014-11-28' + AND fa_fol_b_focal_animid = 'DL' + AND fa_b_arr_animid = 'AO') + OR (fa_fol_date = '2014-12-22' + AND fa_fol_b_focal_animid = 'FO' + AND fa_b_arr_animid = 'AO') + OR (fa_fol_date = '2015-04-08' + AND fa_fol_b_focal_animid = 'EZA' + AND fa_b_arr_animid = 'AO') + OR (fa_fol_date = '2015-04-08' + AND fa_fol_b_focal_animid = 'EZA' + AND fa_b_arr_animid = 'AO') + OR (fa_fol_date = '2003-08-10' + AND fa_fol_b_focal_animid = 'EDG' + AND fa_b_arr_animid = 'AQ') + OR (fa_fol_date = '2003-08-10' + AND fa_fol_b_focal_animid = 'EDG' + AND fa_b_arr_animid = 'AQ') + OR (fa_fol_date = '2003-08-10' + AND fa_fol_b_focal_animid = 'EDG' + AND fa_b_arr_animid = 'AQ') + OR (fa_fol_date = '2003-08-10' + AND fa_fol_b_focal_animid = 'EDG' + AND fa_b_arr_animid = 'AQ') + OR (fa_fol_date = '1986-01-02' + AND fa_fol_b_focal_animid = 'ML' + AND fa_b_arr_animid = 'CA') + OR (fa_fol_date = '1997-09-22' + AND fa_fol_b_focal_animid = 'SA' + AND fa_b_arr_animid = 'CF') + OR (fa_fol_date = '2005-02-19' + AND fa_fol_b_focal_animid = 'AP' + AND fa_b_arr_animid = 'EBO') + OR (fa_fol_date = '2005-02-19' + AND fa_fol_b_focal_animid = 'AP' + AND fa_b_arr_animid = 'EBO') + OR (fa_fol_date = '2005-02-19' + AND fa_fol_b_focal_animid = 'AP' + AND fa_b_arr_animid = 'EBO') + OR (fa_fol_date = '2005-08-03' + AND fa_fol_b_focal_animid = 'RUD' + AND fa_b_arr_animid = 'EBO') + OR (fa_fol_date = '2005-08-24' + AND fa_fol_b_focal_animid = 'KON' + AND fa_b_arr_animid = 'EBO') + OR (fa_fol_date = '2016-05-10' + AND fa_fol_b_focal_animid = 'SN' + AND fa_b_arr_animid = 'EOW') + OR (fa_fol_date = '2013-10-12' + AND fa_fol_b_focal_animid = 'FU' + AND fa_b_arr_animid = 'ERI') + OR (fa_fol_date = '2013-10-12' + AND fa_fol_b_focal_animid = 'FU' + AND fa_b_arr_animid = 'ERI') + OR (fa_fol_date = '2013-10-12' + AND fa_fol_b_focal_animid = 'FU' + AND fa_b_arr_animid = 'ERI') + OR (fa_fol_date = '2013-10-12' + AND fa_fol_b_focal_animid = 'FU' + AND fa_b_arr_animid = 'ERI') + OR (fa_fol_date = '2013-10-12' + AND fa_fol_b_focal_animid = 'FU' + AND fa_b_arr_animid = 'ERI') + OR (fa_fol_date = '2010-07-07' + AND fa_fol_b_focal_animid = 'LUC' + AND fa_b_arr_animid = 'EVA') + OR (fa_fol_date = '2012-05-18' + AND fa_fol_b_focal_animid = 'WL' + AND fa_b_arr_animid = 'FAM') + OR (fa_fol_date = '2012-05-18' + AND fa_fol_b_focal_animid = 'WL' + AND fa_b_arr_animid = 'FAM') + OR (fa_fol_date = '2012-05-18' + AND fa_fol_b_focal_animid = 'WL' + AND fa_b_arr_animid = 'FAM') + OR (fa_fol_date = '2013-11-28' + AND fa_fol_b_focal_animid = 'FN' + AND fa_b_arr_animid = 'FAM') + OR (fa_fol_date = '2013-11-28' + AND fa_fol_b_focal_animid = 'FN' + AND fa_b_arr_animid = 'FAM') + OR (fa_fol_date = '2016-10-03' + AND fa_fol_b_focal_animid = 'AP' + AND fa_b_arr_animid = 'FIT') + OR (fa_fol_date = '2017-01-16' + AND fa_fol_b_focal_animid = 'OTA' + AND fa_b_arr_animid = 'FIT') + OR (fa_fol_date = '2000-02-04' + AND fa_fol_b_focal_animid = 'FD' + AND fa_b_arr_animid = 'GD') + OR (fa_fol_date = '1986-04-23' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'GT') + OR (fa_fol_date = '1986-04-23' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'GT') + OR (fa_fol_date = '2016-04-06' + AND fa_fol_b_focal_animid = 'NUR' + AND fa_b_arr_animid = 'JF') + OR (fa_fol_date = '2000-06-01' + AND fa_fol_b_focal_animid = 'AO' + AND fa_b_arr_animid = 'JK') + OR (fa_fol_date = '2000-06-01' + AND fa_fol_b_focal_animid = 'AO' + AND fa_b_arr_animid = 'JK') + OR (fa_fol_date = '2000-06-01' + AND fa_fol_b_focal_animid = 'AO' + AND fa_b_arr_animid = 'JK') + OR (fa_fol_date = '2000-06-20' + AND fa_fol_b_focal_animid = 'PX' + AND fa_b_arr_animid = 'JK') + OR (fa_fol_date = '2000-06-20' + AND fa_fol_b_focal_animid = 'PX' + AND fa_b_arr_animid = 'JK') + OR (fa_fol_date = '1994-03-06' + AND fa_fol_b_focal_animid = 'WL' + AND fa_b_arr_animid = 'KD') + OR (fa_fol_date = '1983-06-15' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'KR') + OR (fa_fol_date = '2013-08-13' + AND fa_fol_b_focal_animid = 'LOS' + AND fa_b_arr_animid = 'LOD') + OR (fa_fol_date = '2013-09-28' + AND fa_fol_b_focal_animid = 'FAN' + AND fa_b_arr_animid = 'LOD') + OR (fa_fol_date = '2013-09-28' + AND fa_fol_b_focal_animid = 'FAN' + AND fa_b_arr_animid = 'LOD') + OR (fa_fol_date = '2013-10-15' + AND fa_fol_b_focal_animid = 'MGA' + AND fa_b_arr_animid = 'LOD') + OR (fa_fol_date = '2013-10-15' + AND fa_fol_b_focal_animid = 'MGA' + AND fa_b_arr_animid = 'LOD') + OR (fa_fol_date = '2013-10-21' + AND fa_fol_b_focal_animid = 'EDG' + AND fa_b_arr_animid = 'LOD') + OR (fa_fol_date = '2013-10-25' + AND fa_fol_b_focal_animid = 'AP' + AND fa_b_arr_animid = 'LOD') + OR (fa_fol_date = '2013-10-25' + AND fa_fol_b_focal_animid = 'AP' + AND fa_b_arr_animid = 'LOD') + OR (fa_fol_date = '2013-11-23' + AND fa_fol_b_focal_animid = 'KON' + AND fa_b_arr_animid = 'LOD') + OR (fa_fol_date = '2013-11-23' + AND fa_fol_b_focal_animid = 'KON' + AND fa_b_arr_animid = 'LOD') + OR (fa_fol_date = '2013-12-12' + AND fa_fol_b_focal_animid = 'MGA' + AND fa_b_arr_animid = 'LOD') + OR (fa_fol_date = '2013-12-12' + AND fa_fol_b_focal_animid = 'MGA' + AND fa_b_arr_animid = 'LOD') + OR (fa_fol_date = '2013-12-16' + AND fa_fol_b_focal_animid = 'FLI' + AND fa_b_arr_animid = 'LOD') + OR (fa_fol_date = '2014-02-17' + AND fa_fol_b_focal_animid = 'YAM' + AND fa_b_arr_animid = 'LOD') + OR (fa_fol_date = '2014-08-19' + AND fa_fol_b_focal_animid = 'DB' + AND fa_b_arr_animid = 'LOD') + OR (fa_fol_date = '2014-10-27' + AND fa_fol_b_focal_animid = 'WEM' + AND fa_b_arr_animid = 'LOD') + OR (fa_fol_date = '2014-11-30' + AND fa_fol_b_focal_animid = 'MGA' + AND fa_b_arr_animid = 'LOD') + OR (fa_fol_date = '2014-11-30' + AND fa_fol_b_focal_animid = 'MGA' + AND fa_b_arr_animid = 'LOD') + OR (fa_fol_date = '2003-06-16' + AND fa_fol_b_focal_animid = 'EDG' + AND fa_b_arr_animid = 'LOL') + OR (fa_fol_date = '2003-06-16' + AND fa_fol_b_focal_animid = 'EDG' + AND fa_b_arr_animid = 'LOL') + OR (fa_fol_date = '2015-06-29' + AND fa_fol_b_focal_animid = 'LOS' + AND fa_b_arr_animid = 'LOR') + OR (fa_fol_date = '2015-07-26' + AND fa_fol_b_focal_animid = 'FLI' + AND fa_b_arr_animid = 'LTT') + OR (fa_fol_date = '2011-06-22' + AND fa_fol_b_focal_animid = 'LAM' + AND fa_b_arr_animid = 'LUC') + OR (fa_fol_date = '1995-09-03' + AND fa_fol_b_focal_animid = 'PF' + AND fa_b_arr_animid = 'ME') + OR (fa_fol_date = '1975-07-22' + AND fa_fol_b_focal_animid = 'GK' + AND fa_b_arr_animid = 'NV') + OR (fa_fol_date = '1998-02-23' + AND fa_fol_b_focal_animid = 'TB' + AND fa_b_arr_animid = 'PF') + OR (fa_fol_date = '1982-12-06' + AND fa_fol_b_focal_animid = 'LB' + AND fa_b_arr_animid = 'PL') + OR (fa_fol_date = '1982-12-21' + AND fa_fol_b_focal_animid = 'ML' + AND fa_b_arr_animid = 'PL') + OR (fa_fol_date = '2014-07-17' + AND fa_fol_b_focal_animid = 'APL' + AND fa_b_arr_animid = 'RUD') + OR (fa_fol_date = '1998-08-19' + AND fa_fol_b_focal_animid = 'FS' + AND fa_b_arr_animid = 'SEF') + OR (fa_fol_date = '1998-08-19' + AND fa_fol_b_focal_animid = 'FS' + AND fa_b_arr_animid = 'SEF') + OR (fa_fol_date = '2015-10-12' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'SIF') + OR (fa_fol_date = '2015-10-12' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'SIF') + OR (fa_fol_date = '1973-08-30' + AND fa_fol_b_focal_animid = 'EV' + AND fa_b_arr_animid = 'STA') + OR (fa_fol_date = '1973-08-30' + AND fa_fol_b_focal_animid = 'EV' + AND fa_b_arr_animid = 'STA') + OR (fa_fol_date = '1973-09-27' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'STA') + OR (fa_fol_date = '1973-09-28' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'STA') + OR (fa_fol_date = '2015-10-01' + AND fa_fol_b_focal_animid = 'TG' + AND fa_b_arr_animid = 'SW') + OR (fa_fol_date = '2015-10-01' + AND fa_fol_b_focal_animid = 'TG' + AND fa_b_arr_animid = 'SW') + OR (fa_fol_date = '2015-10-07' + AND fa_fol_b_focal_animid = 'IMA' + AND fa_b_arr_animid = 'TAB') + OR (fa_fol_date = '2015-11-27' + AND fa_fol_b_focal_animid = 'RUM' + AND fa_b_arr_animid = 'TAB') + OR (fa_fol_date = '2015-11-27' + AND fa_fol_b_focal_animid = 'RUM' + AND fa_b_arr_animid = 'TAB') + OR (fa_fol_date = '2015-12-07' + AND fa_fol_b_focal_animid = 'ZS' + AND fa_b_arr_animid = 'TN') + OR (fa_fol_date = '2016-04-19' + AND fa_fol_b_focal_animid = 'SI' + AND fa_b_arr_animid = 'TN') + OR (fa_fol_date = '2014-10-02' + AND fa_fol_b_focal_animid = 'SN' + AND fa_b_arr_animid = 'TZN') + OR (fa_fol_date = '2014-10-02' + AND fa_fol_b_focal_animid = 'SN' + AND fa_b_arr_animid = 'TZN') + OR (fa_fol_date = '2014-10-02' + AND fa_fol_b_focal_animid = 'SN' + AND fa_b_arr_animid = 'TZN') + OR (fa_fol_date = '2014-11-01' + AND fa_fol_b_focal_animid = 'SA' + AND fa_b_arr_animid = 'TZN') + OR (fa_fol_date = '2014-11-03' + AND fa_fol_b_focal_animid = 'SA' + AND fa_b_arr_animid = 'TZN') + OR (fa_fol_date = '2016-02-06' + AND fa_fol_b_focal_animid = 'SA' + AND fa_b_arr_animid = 'TZN') + OR (fa_fol_date = '2002-01-09' + AND fa_fol_b_focal_animid = 'FS' + AND fa_b_arr_animid = 'VID') + OR (fa_fol_date = '2002-04-28' + AND fa_fol_b_focal_animid = 'DB' + AND fa_b_arr_animid = 'VID') + OR (fa_fol_date = '2002-07-01' + AND fa_fol_b_focal_animid = 'KON' + AND fa_b_arr_animid = 'VID') + OR (fa_fol_date = '2002-07-07' + AND fa_fol_b_focal_animid = 'EDG' + AND fa_b_arr_animid = 'VID') + OR (fa_fol_date = '2002-07-16' + AND fa_fol_b_focal_animid = 'VIN' + AND fa_b_arr_animid = 'VID') + OR (fa_fol_date = '2002-08-18' + AND fa_fol_b_focal_animid = 'LOR' + AND fa_b_arr_animid = 'VID') + OR (fa_fol_date = '2002-09-08' + AND fa_fol_b_focal_animid = 'LOR' + AND fa_b_arr_animid = 'VID') + OR (fa_fol_date = '2002-10-14' + AND fa_fol_b_focal_animid = 'AQ' + AND fa_b_arr_animid = 'VID') + OR (fa_fol_date = '2002-12-14' + AND fa_fol_b_focal_animid = 'RUD' + AND fa_b_arr_animid = 'VID') + OR (fa_fol_date = '2003-04-24' + AND fa_fol_b_focal_animid = 'BIM' + AND fa_b_arr_animid = 'VID') + OR (fa_fol_date = '2003-04-24' + AND fa_fol_b_focal_animid = 'BIM' + AND fa_b_arr_animid = 'VID') + OR (fa_fol_date = '2003-07-06' + AND fa_fol_b_focal_animid = 'FS' + AND fa_b_arr_animid = 'VID') + OR (fa_fol_date = '2003-07-06' + AND fa_fol_b_focal_animid = 'FS' + AND fa_b_arr_animid = 'VID') + OR (fa_fol_date = '2003-07-06' + AND fa_fol_b_focal_animid = 'FS' + AND fa_b_arr_animid = 'VID') + OR (fa_fol_date = '2003-07-06' + AND fa_fol_b_focal_animid = 'FS' + AND fa_b_arr_animid = 'VID') + OR (fa_fol_date = '2003-08-06' + AND fa_fol_b_focal_animid = 'VAN' + AND fa_b_arr_animid = 'VID') + OR (fa_fol_date = '2003-09-09' + AND fa_fol_b_focal_animid = 'RUD' + AND fa_b_arr_animid = 'VID') + OR (fa_fol_date = '2001-05-17' + AND fa_fol_b_focal_animid = 'AO' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-05-18' + AND fa_fol_b_focal_animid = 'AO' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-05-19' + AND fa_fol_b_focal_animid = 'DL' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-05-20' + AND fa_fol_b_focal_animid = 'CD' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-05-20' + AND fa_fol_b_focal_animid = 'CD' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-05-21' + AND fa_fol_b_focal_animid = 'PI' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-05-22' + AND fa_fol_b_focal_animid = 'FN' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-05-22' + AND fa_fol_b_focal_animid = 'FN' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-05-23' + AND fa_fol_b_focal_animid = 'PX' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-05-24' + AND fa_fol_b_focal_animid = 'PI' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-05-26' + AND fa_fol_b_focal_animid = 'FR' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-05-27' + AND fa_fol_b_focal_animid = 'PX' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-05-28' + AND fa_fol_b_focal_animid = 'FD' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-05-28' + AND fa_fol_b_focal_animid = 'FD' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-05-28' + AND fa_fol_b_focal_animid = 'FD' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-06-04' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-06-04' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-07-01' + AND fa_fol_b_focal_animid = 'FR' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-07-01' + AND fa_fol_b_focal_animid = 'FR' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-07-13' + AND fa_fol_b_focal_animid = 'SL' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-07-14' + AND fa_fol_b_focal_animid = 'SL' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-07-15' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-08-15' + AND fa_fol_b_focal_animid = 'SL' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-08-15' + AND fa_fol_b_focal_animid = 'SL' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-09-05' + AND fa_fol_b_focal_animid = 'FR' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-09-05' + AND fa_fol_b_focal_animid = 'FR' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-09-05' + AND fa_fol_b_focal_animid = 'FR' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-09-10' + AND fa_fol_b_focal_animid = 'AO' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-09-10' + AND fa_fol_b_focal_animid = 'AO' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-09-24' + AND fa_fol_b_focal_animid = 'TB' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-09-24' + AND fa_fol_b_focal_animid = 'TB' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-09-24' + AND fa_fol_b_focal_animid = 'TB' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-09-25' + AND fa_fol_b_focal_animid = 'PX' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-09-26' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-09-26' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-09-26' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-09-27' + AND fa_fol_b_focal_animid = 'SS' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-09-27' + AND fa_fol_b_focal_animid = 'SS' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-09-27' + AND fa_fol_b_focal_animid = 'SS' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-09-27' + AND fa_fol_b_focal_animid = 'SS' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-09-27' + AND fa_fol_b_focal_animid = 'SS' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-09-28' + AND fa_fol_b_focal_animid = 'DL' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-09-28' + AND fa_fol_b_focal_animid = 'DL' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-09-29' + AND fa_fol_b_focal_animid = 'TG' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-09-29' + AND fa_fol_b_focal_animid = 'TG' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-09-29' + AND fa_fol_b_focal_animid = 'TG' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-09-29' + AND fa_fol_b_focal_animid = 'TG' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-09-29' + AND fa_fol_b_focal_animid = 'TG' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-09-30' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-09-30' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-10-01' + AND fa_fol_b_focal_animid = 'FD' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-10-01' + AND fa_fol_b_focal_animid = 'FD' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-10-10' + AND fa_fol_b_focal_animid = 'SW' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-10-10' + AND fa_fol_b_focal_animid = 'SW' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-11-04' + AND fa_fol_b_focal_animid = 'TB' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-11-12' + AND fa_fol_b_focal_animid = 'KS' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-11-13' + AND fa_fol_b_focal_animid = 'SL' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-11-15' + AND fa_fol_b_focal_animid = 'TB' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-11-16' + AND fa_fol_b_focal_animid = 'BE' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-11-17' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-11-19' + AND fa_fol_b_focal_animid = 'FN' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-11-21' + AND fa_fol_b_focal_animid = 'DL' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-11-22' + AND fa_fol_b_focal_animid = 'FR' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-11-24' + AND fa_fol_b_focal_animid = 'PI' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-11-24' + AND fa_fol_b_focal_animid = 'PI' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-11-24' + AND fa_fol_b_focal_animid = 'PI' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-11-24' + AND fa_fol_b_focal_animid = 'PI' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-11-27' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-11-28' + AND fa_fol_b_focal_animid = 'SW' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-11-28' + AND fa_fol_b_focal_animid = 'SW' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-12-02' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-12-02' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-12-02' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-12-02' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-12-02' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-12-22' + AND fa_fol_b_focal_animid = 'JF' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-12-23' + AND fa_fol_b_focal_animid = 'SIF' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-12-24' + AND fa_fol_b_focal_animid = 'SA' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-12-25' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-12-26' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-12-27' + AND fa_fol_b_focal_animid = 'PX' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-12-27' + AND fa_fol_b_focal_animid = 'PX' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-12-27' + AND fa_fol_b_focal_animid = 'PX' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2002-01-05' + AND fa_fol_b_focal_animid = 'AO' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2002-01-06' + AND fa_fol_b_focal_animid = 'FR' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2002-01-06' + AND fa_fol_b_focal_animid = 'FR' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2002-01-06' + AND fa_fol_b_focal_animid = 'FR' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2002-01-07' + AND fa_fol_b_focal_animid = 'KS' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2002-01-07' + AND fa_fol_b_focal_animid = 'KS' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2002-01-07' + AND fa_fol_b_focal_animid = 'KS' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2002-01-10' + AND fa_fol_b_focal_animid = 'TB' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2002-01-11' + AND fa_fol_b_focal_animid = 'CD' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2002-01-12' + AND fa_fol_b_focal_animid = 'BE' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2002-01-13' + AND fa_fol_b_focal_animid = 'KS' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2002-01-14' + AND fa_fol_b_focal_animid = 'BE' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2002-01-16' + AND fa_fol_b_focal_animid = 'FR' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2002-01-17' + AND fa_fol_b_focal_animid = 'FN' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2002-01-18' + AND fa_fol_b_focal_animid = 'SL' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2002-01-19' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2002-01-19' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2002-01-19' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2002-01-20' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2002-01-25' + AND fa_fol_b_focal_animid = 'TG' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2002-01-25' + AND fa_fol_b_focal_animid = 'TG' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2002-01-25' + AND fa_fol_b_focal_animid = 'TG' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2002-01-25' + AND fa_fol_b_focal_animid = 'TG' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2002-02-19' + AND fa_fol_b_focal_animid = 'SL' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2002-02-19' + AND fa_fol_b_focal_animid = 'SL' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2002-02-20' + AND fa_fol_b_focal_animid = 'SA' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2002-02-20' + AND fa_fol_b_focal_animid = 'SA' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2002-02-25' + AND fa_fol_b_focal_animid = 'JF' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2002-02-25' + AND fa_fol_b_focal_animid = 'JF' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2002-02-26' + AND fa_fol_b_focal_animid = 'FR' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2002-03-07' + AND fa_fol_b_focal_animid = 'FR' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2002-03-08' + AND fa_fol_b_focal_animid = 'AO' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2002-03-08' + AND fa_fol_b_focal_animid = 'AO' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2002-11-24' + AND fa_fol_b_focal_animid = 'TG' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2003-01-20' + AND fa_fol_b_focal_animid = 'AO' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-11-18' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'WN') + OR (fa_fol_date = '2001-11-18' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'WN') + OR (fa_fol_date = '2001-11-18' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'WN') + OR (fa_fol_date = '2016-07-16' + AND fa_fol_b_focal_animid = 'FAN' + AND fa_b_arr_animid = 'YAM') + OR (fa_fol_date = '2016-07-16' + AND fa_fol_b_focal_animid = 'FAN' + AND fa_b_arr_animid = 'YAM') + OR (fa_fol_date = '2016-07-16' + AND fa_fol_b_focal_animid = 'FAN' + AND fa_b_arr_animid = 'YOY') + OR (fa_fol_date = '2016-07-16' + AND fa_fol_b_focal_animid = 'FAN' + AND fa_b_arr_animid = 'YOY') + OR (fa_fol_date = '2013-10-12' + AND fa_fol_b_focal_animid = 'FU' + AND fa_b_arr_animid = 'ZIN') + OR (fa_fol_date = '2013-10-12' + AND fa_fol_b_focal_animid = 'FU' + AND fa_b_arr_animid = 'ZIN')) + AND NOT -- Problem #49 + -- select follow_arrival.fa_fol_date + -- , follow_arrival.fa_fol_b_focal_animid + -- , follow_arrival.fa_b_arr_animid + -- from clean.follow_arrival + -- join clean.biography + -- on (biography.b_animid = follow_arrival.fa_b_arr_animid) + -- where biography.b_sex = 'F' + -- and follow_arrival.fa_type_of_cycle = 'U' + -- and biography.b_birthdate + -- <= (follow_arrival.fa_fol_date + -- - '1 year'::INTERVAL + -- - '14 years'::INTERVAL + -- ) + -- order by follow_arrival.fa_fol_date + -- , follow_arrival.fa_fol_b_focal_animid + -- , follow_arrival.fa_b_arr_animid; + ((fa_fol_date = '1973-05-06' + AND fa_fol_b_focal_animid = 'GG' + AND fa_b_arr_animid = 'GG') + OR (fa_fol_date = '1973-05-08' + AND fa_fol_b_focal_animid = 'WK' + AND fa_b_arr_animid = 'ML') + OR (fa_fol_date = '1973-05-08' + AND fa_fol_b_focal_animid = 'WK' + AND fa_b_arr_animid = 'PS') + OR (fa_fol_date = '1973-05-10' + AND fa_fol_b_focal_animid = 'FG' + AND fa_b_arr_animid = 'GG') + OR (fa_fol_date = '1973-05-13' + AND fa_fol_b_focal_animid = 'JJ' + AND fa_b_arr_animid = 'ML') + OR (fa_fol_date = '1973-05-14' + AND fa_fol_b_focal_animid = 'EV' + AND fa_b_arr_animid = 'ML') + OR (fa_fol_date = '1973-05-16' + AND fa_fol_b_focal_animid = 'HG' + AND fa_b_arr_animid = 'AT') + OR (fa_fol_date = '1973-05-16' + AND fa_fol_b_focal_animid = 'HG' + AND fa_b_arr_animid = 'PS') + OR (fa_fol_date = '1973-05-16' + AND fa_fol_b_focal_animid = 'JJ' + AND fa_b_arr_animid = 'ML') + OR (fa_fol_date = '1973-05-17' + AND fa_fol_b_focal_animid = 'MK' + AND fa_b_arr_animid = 'PL') + OR (fa_fol_date = '1973-05-18' + AND fa_fol_b_focal_animid = 'ST' + AND fa_b_arr_animid = 'PL') + OR (fa_fol_date = '1973-05-21' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'PL') + OR (fa_fol_date = '1973-05-23' + AND fa_fol_b_focal_animid = 'ML' + AND fa_b_arr_animid = 'PS') + OR (fa_fol_date = '1973-05-24' + AND fa_fol_b_focal_animid = 'GK' + AND fa_b_arr_animid = 'DO') + OR (fa_fol_date = '1973-08-04' + AND fa_fol_b_focal_animid = 'EV' + AND fa_b_arr_animid = 'FF') + OR (fa_fol_date = '1973-08-04' + AND fa_fol_b_focal_animid = 'EV' + AND fa_b_arr_animid = 'WK') + OR (fa_fol_date = '1973-08-04' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'ML') + OR (fa_fol_date = '1973-10-15' + AND fa_fol_b_focal_animid = 'ML' + AND fa_b_arr_animid = 'NP') + OR (fa_fol_date = '1973-10-16' + AND fa_fol_b_focal_animid = 'AT' + AND fa_b_arr_animid = 'AT') + OR (fa_fol_date = '1973-10-16' + AND fa_fol_b_focal_animid = 'PS' + AND fa_b_arr_animid = 'PS') + OR (fa_fol_date = '1973-10-18' + AND fa_fol_b_focal_animid = 'SF' + AND fa_b_arr_animid = 'MB') + OR (fa_fol_date = '1973-10-20' + AND fa_fol_b_focal_animid = 'AT' + AND fa_b_arr_animid = 'AT') + OR (fa_fol_date = '1973-10-26' + AND fa_fol_b_focal_animid = 'FB' + AND fa_b_arr_animid = 'ML') + OR (fa_fol_date = '1985-06-10' + AND fa_fol_b_focal_animid = 'GG' + AND fa_b_arr_animid = 'SS') + OR (fa_fol_date = '1985-06-10' + AND fa_fol_b_focal_animid = 'GG' + AND fa_b_arr_animid = 'SS') + OR (fa_fol_date = '1985-06-10' + AND fa_fol_b_focal_animid = 'GG' + AND fa_b_arr_animid = 'SS') + OR (fa_fol_date = '1985-06-10' + AND fa_fol_b_focal_animid = 'GG' + AND fa_b_arr_animid = 'SS') + OR (fa_fol_date = '1985-06-10' + AND fa_fol_b_focal_animid = 'GG' + AND fa_b_arr_animid = 'SS') + OR (fa_fol_date = '1985-06-10' + AND fa_fol_b_focal_animid = 'GG' + AND fa_b_arr_animid = 'SS') + OR (fa_fol_date = '1985-06-10' + AND fa_fol_b_focal_animid = 'GG' + AND fa_b_arr_animid = 'SS') + OR (fa_fol_date = '1985-06-10' + AND fa_fol_b_focal_animid = 'GG' + AND fa_b_arr_animid = 'SS') + OR (fa_fol_date = '1995-02-04' + AND fa_fol_b_focal_animid = 'PF' + AND fa_b_arr_animid = 'JF') + OR (fa_fol_date = '1995-02-04' + AND fa_fol_b_focal_animid = 'PF' + AND fa_b_arr_animid = 'JF') + OR (fa_fol_date = '1995-02-04' + AND fa_fol_b_focal_animid = 'PF' + AND fa_b_arr_animid = 'JF') + OR (fa_fol_date = '2001-07-14' + AND fa_fol_b_focal_animid = 'SL' + AND fa_b_arr_animid = 'MGF') + OR (fa_fol_date = '2001-10-23' + AND fa_fol_b_focal_animid = 'KS' + AND fa_b_arr_animid = 'MGF') + OR (fa_fol_date = '2001-10-24' + AND fa_fol_b_focal_animid = 'PX' + AND fa_b_arr_animid = 'MGF') + OR (fa_fol_date = '2001-10-25' + AND fa_fol_b_focal_animid = 'PX' + AND fa_b_arr_animid = 'MGF') + OR (fa_fol_date = '2002-04-29' + AND fa_fol_b_focal_animid = 'WL' + AND fa_b_arr_animid = 'MGF') + OR (fa_fol_date = '2002-04-29' + AND fa_fol_b_focal_animid = 'WL' + AND fa_b_arr_animid = 'MGF') + OR (fa_fol_date = '2002-04-29' + AND fa_fol_b_focal_animid = 'WL' + AND fa_b_arr_animid = 'MGF') + OR (fa_fol_date = '2002-11-09' + AND fa_fol_b_focal_animid = 'AO' + AND fa_b_arr_animid = 'MGF') + OR (fa_fol_date = '2002-11-10' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'MGF') + OR (fa_fol_date = '2002-11-10' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'MGF') + OR (fa_fol_date = '2002-11-12' + AND fa_fol_b_focal_animid = 'FD' + AND fa_b_arr_animid = 'MGF') + OR (fa_fol_date = '2002-11-12' + AND fa_fol_b_focal_animid = 'FD' + AND fa_b_arr_animid = 'MGF') + OR (fa_fol_date = '2002-11-24' + AND fa_fol_b_focal_animid = 'TG' + AND fa_b_arr_animid = 'MGF') + OR (fa_fol_date = '2003-08-30' + AND fa_fol_b_focal_animid = 'WL' + AND fa_b_arr_animid = 'SW') + OR (fa_fol_date = '2003-11-15' + AND fa_fol_b_focal_animid = 'VIN' + AND fa_b_arr_animid = 'VAN') + OR (fa_fol_date = '2003-11-18' + AND fa_fol_b_focal_animid = 'LOR' + AND fa_b_arr_animid = 'VAN') + OR (fa_fol_date = '2003-11-20' + AND fa_fol_b_focal_animid = 'BIM' + AND fa_b_arr_animid = 'VAN') + OR (fa_fol_date = '2003-11-20' + AND fa_fol_b_focal_animid = 'BIM' + AND fa_b_arr_animid = 'VAN') + OR (fa_fol_date = '2003-11-20' + AND fa_fol_b_focal_animid = 'BIM' + AND fa_b_arr_animid = 'VAN') + OR (fa_fol_date = '2003-11-21' + AND fa_fol_b_focal_animid = 'KON' + AND fa_b_arr_animid = 'VAN') + OR (fa_fol_date = '2004-01-10' + AND fa_fol_b_focal_animid = 'VIN' + AND fa_b_arr_animid = 'VAN') + OR (fa_fol_date = '2004-01-10' + AND fa_fol_b_focal_animid = 'VIN' + AND fa_b_arr_animid = 'VAN') + OR (fa_fol_date = '2004-01-10' + AND fa_fol_b_focal_animid = 'VIN' + AND fa_b_arr_animid = 'VAN') + OR (fa_fol_date = '2004-01-10' + AND fa_fol_b_focal_animid = 'VIN' + AND fa_b_arr_animid = 'VAN') + OR (fa_fol_date = '2004-01-12' + AND fa_fol_b_focal_animid = 'VIN' + AND fa_b_arr_animid = 'MGF') + OR (fa_fol_date = '2004-01-12' + AND fa_fol_b_focal_animid = 'VIN' + AND fa_b_arr_animid = 'VAN') + OR (fa_fol_date = '2004-02-20' + AND fa_fol_b_focal_animid = 'EDG' + AND fa_b_arr_animid = 'VAN') + OR (fa_fol_date = '2004-02-20' + AND fa_fol_b_focal_animid = 'EDG' + AND fa_b_arr_animid = 'VAN') + OR (fa_fol_date = '2004-02-21' + AND fa_fol_b_focal_animid = 'FS' + AND fa_b_arr_animid = 'VAN') + OR (fa_fol_date = '2004-07-21' + AND fa_fol_b_focal_animid = 'KON' + AND fa_b_arr_animid = 'VAN') + OR (fa_fol_date = '2004-07-27' + AND fa_fol_b_focal_animid = 'VAN' + AND fa_b_arr_animid = 'VAN') + OR (fa_fol_date = '2004-07-29' + AND fa_fol_b_focal_animid = 'KON' + AND fa_b_arr_animid = 'VAN') + OR (fa_fol_date = '2004-07-30' + AND fa_fol_b_focal_animid = 'LOR' + AND fa_b_arr_animid = 'VAN') + OR (fa_fol_date = '2004-09-23' + AND fa_fol_b_focal_animid = 'KON' + AND fa_b_arr_animid = 'VAN') + OR (fa_fol_date = '2004-09-24' + AND fa_fol_b_focal_animid = 'KON' + AND fa_b_arr_animid = 'VAN') + OR (fa_fol_date = '2004-12-02' + AND fa_fol_b_focal_animid = 'FD' + AND fa_b_arr_animid = 'ECO') + OR (fa_fol_date = '2005-03-07' + AND fa_fol_b_focal_animid = 'GL' + AND fa_b_arr_animid = 'TG') + OR (fa_fol_date = '2005-05-25' + AND fa_fol_b_focal_animid = 'NAS' + AND fa_b_arr_animid = 'HO') + OR (fa_fol_date = '2005-06-08' + AND fa_fol_b_focal_animid = 'FLI' + AND fa_b_arr_animid = 'BAH') + OR (fa_fol_date = '2005-07-11' + AND fa_fol_b_focal_animid = 'NUR' + AND fa_b_arr_animid = 'HO') + OR (fa_fol_date = '2005-07-12' + AND fa_fol_b_focal_animid = 'WL' + AND fa_b_arr_animid = 'SW') + OR (fa_fol_date = '2005-07-30' + AND fa_fol_b_focal_animid = 'KP' + AND fa_b_arr_animid = 'PI') + OR (fa_fol_date = '2005-07-30' + AND fa_fol_b_focal_animid = 'KP' + AND fa_b_arr_animid = 'PI') + OR (fa_fol_date = '2005-08-21' + AND fa_fol_b_focal_animid = 'SR' + AND fa_b_arr_animid = 'BAH') + OR (fa_fol_date = '2006-09-23' + AND fa_fol_b_focal_animid = 'KON' + AND fa_b_arr_animid = 'LUC') + OR (fa_fol_date = '2006-09-23' + AND fa_fol_b_focal_animid = 'KON' + AND fa_b_arr_animid = 'LUC') + OR (fa_fol_date = '2009-07-10' + AND fa_fol_b_focal_animid = 'FO' + AND fa_b_arr_animid = 'MGF') + OR (fa_fol_date = '2009-07-18' + AND fa_fol_b_focal_animid = 'ZS' + AND fa_b_arr_animid = 'MGF') + OR (fa_fol_date = '2012-08-12' + AND fa_fol_b_focal_animid = 'GLD' + AND fa_b_arr_animid = 'MGF') + OR (fa_fol_date = '2012-08-12' + AND fa_fol_b_focal_animid = 'GLD' + AND fa_b_arr_animid = 'MGF') + OR (fa_fol_date = '2012-08-12' + AND fa_fol_b_focal_animid = 'GLD' + AND fa_b_arr_animid = 'MGF') + OR (fa_fol_date = '2012-08-12' + AND fa_fol_b_focal_animid = 'GLD' + AND fa_b_arr_animid = 'SI') + OR (fa_fol_date = '2012-08-12' + AND fa_fol_b_focal_animid = 'GLD' + AND fa_b_arr_animid = 'SI') + OR (fa_fol_date = '2012-08-12' + AND fa_fol_b_focal_animid = 'GLD' + AND fa_b_arr_animid = 'SI') + OR (fa_fol_date = '2012-08-12' + AND fa_fol_b_focal_animid = 'GLD' + AND fa_b_arr_animid = 'SW') + OR (fa_fol_date = '2012-08-12' + AND fa_fol_b_focal_animid = 'GLD' + AND fa_b_arr_animid = 'SW') + OR (fa_fol_date = '2012-08-12' + AND fa_fol_b_focal_animid = 'GLD' + AND fa_b_arr_animid = 'SW') + OR (fa_fol_date = '2012-08-12' + AND fa_fol_b_focal_animid = 'GLD' + AND fa_b_arr_animid = 'SW') + OR (fa_fol_date = '2012-08-15' + AND fa_fol_b_focal_animid = 'RUM' + AND fa_b_arr_animid = 'BAH') + OR (fa_fol_date = '2012-08-20' + AND fa_fol_b_focal_animid = 'ZS' + AND fa_b_arr_animid = 'MKW') + OR (fa_fol_date = '2012-08-20' + AND fa_fol_b_focal_animid = 'ZS' + AND fa_b_arr_animid = 'MKW') + OR (fa_fol_date = '2012-08-25' + AND fa_fol_b_focal_animid = 'GLI' + AND fa_b_arr_animid = 'DL') + OR (fa_fol_date = '2012-09-06' + AND fa_fol_b_focal_animid = 'TZ' + AND fa_b_arr_animid = 'TG') + OR (fa_fol_date = '2012-09-06' + AND fa_fol_b_focal_animid = 'TZ' + AND fa_b_arr_animid = 'TG') + OR (fa_fol_date = '2012-09-08' + AND fa_fol_b_focal_animid = 'FN' + AND fa_b_arr_animid = 'GM') + OR (fa_fol_date = '2012-09-18' + AND fa_fol_b_focal_animid = 'GLD' + AND fa_b_arr_animid = 'FN') + OR (fa_fol_date = '2012-09-18' + AND fa_fol_b_focal_animid = 'GLD' + AND fa_b_arr_animid = 'FN') + OR (fa_fol_date = '2012-09-20' + AND fa_fol_b_focal_animid = 'SDB' + AND fa_b_arr_animid = 'VAN') + OR (fa_fol_date = '2012-09-20' + AND fa_fol_b_focal_animid = 'SDB' + AND fa_b_arr_animid = 'VAN') + OR (fa_fol_date = '2012-09-20' + AND fa_fol_b_focal_animid = 'SDB' + AND fa_b_arr_animid = 'VAN') + OR (fa_fol_date = '2012-09-20' + AND fa_fol_b_focal_animid = 'SDB' + AND fa_b_arr_animid = 'VAN') + OR (fa_fol_date = '2012-09-22' + AND fa_fol_b_focal_animid = 'SAM' + AND fa_b_arr_animid = 'MKW') + OR (fa_fol_date = '2013-09-27' + AND fa_fol_b_focal_animid = 'FND' + AND fa_b_arr_animid = 'NUR') + OR (fa_fol_date = '2014-01-07' + AND fa_fol_b_focal_animid = 'GLI' + AND fa_b_arr_animid = 'MGF') + OR (fa_fol_date = '2014-01-07' + AND fa_fol_b_focal_animid = 'GLI' + AND fa_b_arr_animid = 'MGF') + OR (fa_fol_date = '2016-04-13' + AND fa_fol_b_focal_animid = 'FU' + AND fa_b_arr_animid = 'MGF') + OR (fa_fol_date = '2016-05-01' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'MGF2') + OR (fa_fol_date = '2016-05-01' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'MGF2') + OR (fa_fol_date = '2016-05-17' + AND fa_fol_b_focal_animid = 'SI' + AND fa_b_arr_animid = 'MGF2') + OR (fa_fol_date = '2016-05-18' + AND fa_fol_b_focal_animid = 'SL' + AND fa_b_arr_animid = 'MGF2') + OR (fa_fol_date = '2016-06-22' + AND fa_fol_b_focal_animid = 'FU' + AND fa_b_arr_animid = 'MGF2') + OR (fa_fol_date = '2016-06-25' + AND fa_fol_b_focal_animid = 'FE' + AND fa_b_arr_animid = 'MGF2') + OR (fa_fol_date = '2016-08-22' + AND fa_fol_b_focal_animid = 'MKW' + AND fa_b_arr_animid = 'MGF2') + OR (fa_fol_date = '2016-08-22' + AND fa_fol_b_focal_animid = 'MKW' + AND fa_b_arr_animid = 'MGF2') + OR (fa_fol_date = '2016-08-22' + AND fa_fol_b_focal_animid = 'MKW' + AND fa_b_arr_animid = 'MGF2') + OR (fa_fol_date = '2016-08-22' + AND fa_fol_b_focal_animid = 'MKW' + AND fa_b_arr_animid = 'MGF2') + OR (fa_fol_date = '2016-09-27' + AND fa_fol_b_focal_animid = 'RUM' + AND fa_b_arr_animid = 'MGF') + OR (fa_fol_date = '2016-11-09' + AND fa_fol_b_focal_animid = 'GLD' + AND fa_b_arr_animid = 'MGF') + OR (fa_fol_date = '2016-11-09' + AND fa_fol_b_focal_animid = 'GLD' + AND fa_b_arr_animid = 'MGF') + OR (fa_fol_date = '2016-11-10' + AND fa_fol_b_focal_animid = 'GLI' + AND fa_b_arr_animid = 'MGF') + OR (fa_fol_date = '2016-11-10' + AND fa_fol_b_focal_animid = 'GLI' + AND fa_b_arr_animid = 'MGF') + OR (fa_fol_date = '2016-11-10' + AND fa_fol_b_focal_animid = 'GLI' + AND fa_b_arr_animid = 'MGF') + OR (fa_fol_date = '2016-11-10' + AND fa_fol_b_focal_animid = 'GLI' + AND fa_b_arr_animid = 'MGF')) + AND NOT -- Problem #53 + fa_b_arr_animid IN ('AMA', 'OBE', 'UWE') + AND NOT -- Problem #11 + fa_b_arr_animid = 'KAZ' + AND NOT -- Problem #54 + -- select follow_arrival.fa_fol_date + -- , follow_arrival.fa_fol_b_focal_animid + -- , follow_arrival.fa_b_arr_animid + -- from clean.follow_arrival + -- join clean.biography + -- on (biography.b_animid = follow_arrival.fa_b_arr_animid) + -- where biography.b_sex = 'F' + -- and follow_arrival.fa_type_of_cycle <> '0' + -- and follow_arrival.fa_type_of_cycle <> 'U' + -- and follow_arrival.fa_type_of_cycle <> 'MISS' + -- and biography.b_birthdate + -- > (follow_arrival.fa_fol_date + -- - '8 years'::INTERVAL + -- ) + -- and follow_arrival.fa_b_arr_animid <> 'sdb_stranger_female' + -- and follow_arrival.fa_b_arr_animid <> 'sdb_stranger_female2' + -- and follow_arrival.fa_b_arr_animid <> 'sdb_stranger_female3' + -- order by follow_arrival.fa_fol_date + -- , follow_arrival.fa_fol_b_focal_animid + -- , follow_arrival.fa_b_arr_animid; + ((fa_fol_date = '1978-05-22' + AND fa_fol_b_focal_animid = 'ML' + AND fa_b_arr_animid = 'GM') + OR (fa_fol_date = '1988-08-01' + AND fa_fol_b_focal_animid = 'DB' + AND fa_b_arr_animid = 'FN') + OR (fa_fol_date = '1988-08-01' + AND fa_fol_b_focal_animid = 'WN' + AND fa_b_arr_animid = 'FN') + OR (fa_fol_date = '1991-08-07' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'FS') + OR (fa_fol_date = '1991-08-07' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'FS') + OR (fa_fol_date = '1991-08-07' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'FS') + OR (fa_fol_date = '1991-08-07' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'TT') + OR (fa_fol_date = '1991-09-24' + AND fa_fol_b_focal_animid = 'GL' + AND fa_b_arr_animid = 'TT') + OR (fa_fol_date = '1992-10-30' + AND fa_fol_b_focal_animid = 'WL' + AND fa_b_arr_animid = 'DL') + OR (fa_fol_date = '1992-10-30' + AND fa_fol_b_focal_animid = 'WL' + AND fa_b_arr_animid = 'DL') + OR (fa_fol_date = '1992-10-30' + AND fa_fol_b_focal_animid = 'WL' + AND fa_b_arr_animid = 'DL') + OR (fa_fol_date = '1992-10-30' + AND fa_fol_b_focal_animid = 'WL' + AND fa_b_arr_animid = 'DL') + OR (fa_fol_date = '1992-10-30' + AND fa_fol_b_focal_animid = 'WL' + AND fa_b_arr_animid = 'DL') + OR (fa_fol_date = '1992-10-30' + AND fa_fol_b_focal_animid = 'WL' + AND fa_b_arr_animid = 'DL') + OR (fa_fol_date = '1992-10-30' + AND fa_fol_b_focal_animid = 'WL' + AND fa_b_arr_animid = 'DL') + OR (fa_fol_date = '1992-10-30' + AND fa_fol_b_focal_animid = 'WL' + AND fa_b_arr_animid = 'DL') + OR (fa_fol_date = '1992-10-30' + AND fa_fol_b_focal_animid = 'WL' + AND fa_b_arr_animid = 'DL') + OR (fa_fol_date = '1994-02-04' + AND fa_fol_b_focal_animid = 'FR' + AND fa_b_arr_animid = 'DL') + OR (fa_fol_date = '1994-05-02' + AND fa_fol_b_focal_animid = 'SEF' + AND fa_b_arr_animid = 'VAN') + OR (fa_fol_date = '1994-05-02' + AND fa_fol_b_focal_animid = 'SEF' + AND fa_b_arr_animid = 'VAN') + OR (fa_fol_date = '1994-11-30' + AND fa_fol_b_focal_animid = 'VID' + AND fa_b_arr_animid = 'BIM') + OR (fa_fol_date = '1994-11-30' + AND fa_fol_b_focal_animid = 'VID' + AND fa_b_arr_animid = 'BIM') + OR (fa_fol_date = '1994-11-30' + AND fa_fol_b_focal_animid = 'VID' + AND fa_b_arr_animid = 'BIM') + OR (fa_fol_date = '1999-06-28' + AND fa_fol_b_focal_animid = 'BAH' + AND fa_b_arr_animid = 'BIM') + OR (fa_fol_date = '2015-09-30' + AND fa_fol_b_focal_animid = 'FLI' + AND fa_b_arr_animid = 'FIT') + OR (fa_fol_date = '2016-12-31' + AND fa_fol_b_focal_animid = 'BIM' + AND fa_b_arr_animid = 'MIS')) ORDER BY follow_arrival.fa_fol_date , follow_arrival.fa_fol_b_focal_animid , follow_arrival.fa_b_arr_animid diff --git a/conversion/load_follow_to_follows.sql b/conversion/load_follow_to_follows.sql index 8bce4f7..29bdf85 100644 --- a/conversion/load_follow_to_follows.sql +++ b/conversion/load_follow_to_follows.sql @@ -65,6 +65,58 @@ SELECT fol_b_animid , fol_date , '' FROM clean.follow + + WHERE + -- Problem #30 + NOT ((fol_date = '1973-02-25' + AND fol_b_animid = 'LON') + OR (fol_date = '1973-07-12' + AND fol_b_animid = 'GO') + OR (fol_date = '1973-07-13' + AND fol_b_animid = 'GO') + OR (fol_date = '1973-07-14' + AND fol_b_animid = 'GO') + OR (fol_date = '2006-04-11' + AND fol_b_animid = 'MGE') + OR (fol_date = '2014-01-20' + AND fol_b_animid = 'MGE') + OR (fol_date = '2014-02-11' + AND fol_b_animid = 'MGE') + OR (fol_date = '2014-03-12' + AND fol_b_animid = 'MGE') + OR (fol_date = '2014-03-16' + AND fol_b_animid = 'MGE') + OR (fol_date = '2014-03-23' + AND fol_b_animid = 'MGE') + OR (fol_date = '2014-04-19' + AND fol_b_animid = 'MGENI') + OR (fol_date = '2014-06-18' + AND fol_b_animid = 'MGENI2') + OR (fol_date = '2014-07-01' + AND fol_b_animid = 'MGENI2')) + + -- Problem #33 + AND (fol_b_animid NOT IN ( + 'MGE' +, 'MGEN' +, 'MGENI')) + -- Problem #34 + AND NOT ((fol_b_animid = 'SL' + AND fol_date = '2014-06-25') + OR (fol_b_animid = 'SN' + AND fol_date = '2013-02-05')) + -- Problem #35 + AND NOT ((fol_b_animid = 'LON' + AND fol_date = '1973-02-25') + OR (fol_b_animid = 'GO' + AND fol_date = '1973-05-31') + OR (fol_b_animid = 'GO' + AND fol_date = '1973-07-12') + OR (fol_b_animid = 'GO' + AND fol_date = '1973-07-13') + OR (fol_b_animid = 'GO' + AND fol_date = '1973-07-14')) + ORDER BY fol_b_animid, fol_date; @@ -146,7 +198,65 @@ SELECT , 'UNK' , 'NONE' , 'NONE' - FROM clean.follow; + FROM clean.follow + WHERE + -- Problem #37 + (fol_date = '1974-01-10' AND fol_b_animid = 'SW') + OR (fol_date = '1974-01-18' AND fol_b_animid = 'PL') + OR (fol_date = '1974-08-13' AND fol_b_animid = 'PM') + OR (fol_date = '1974-12-18' AND fol_b_animid = 'HG') + OR (fol_date = '1975-01-08' AND fol_b_animid = 'NV') + OR (fol_date = '1975-01-15' AND fol_b_animid = 'ST') + OR (fol_date = '1975-01-16' AND fol_b_animid = 'FB') + OR (fol_date = '1975-02-05' AND fol_b_animid = 'GB') + OR (fol_date = '1975-04-20' AND fol_b_animid = 'LB') + OR (fol_date = '1977-08-03' AND fol_b_animid = 'ML') + OR (fol_date = '1977-09-21' AND fol_b_animid = 'ML') + OR (fol_date = '1977-12-02' AND fol_b_animid = 'HR') + OR (fol_date = '1978-04-14' AND fol_b_animid = 'SH') + OR (fol_date = '1978-05-16' AND fol_b_animid = 'HM') + OR (fol_date = '1978-06-05' AND fol_b_animid = 'FG') + OR (fol_date = '1978-06-28' AND fol_b_animid = 'MU') + OR (fol_date = '1978-07-05' AND fol_b_animid = 'FF') + OR (fol_date = '1978-07-06' AND fol_b_animid = 'FG') + OR (fol_date = '1978-07-10' AND fol_b_animid = 'GB') + OR (fol_date = '1978-07-24' AND fol_b_animid = 'GB') + OR (fol_date = '1978-08-11' AND fol_b_animid = 'GB') + OR (fol_date = '1978-12-30' AND fol_b_animid = 'EV') + OR (fol_date = '1979-03-02' AND fol_b_animid = 'HR') + OR (fol_date = '1979-03-14' AND fol_b_animid = 'FG') + OR (fol_date = '1979-04-14' AND fol_b_animid = 'FG') + OR (fol_date = '1979-04-26' AND fol_b_animid = 'SH') + OR (fol_date = '1980-10-27' AND fol_b_animid = 'ML') + OR (fol_date = '1980-10-31' AND fol_b_animid = 'ML') + OR (fol_date = '1981-07-22' AND fol_b_animid = 'MF') + OR (fol_date = '1981-07-26' AND fol_b_animid = 'MU') + OR (fol_date = '1981-07-27' AND fol_b_animid = 'MF') + OR (fol_date = '1981-08-17' AND fol_b_animid = 'MF') + OR (fol_date = '1981-08-18' AND fol_b_animid = 'MF') + OR (fol_date = '1982-02-09' AND fol_b_animid = 'EV') + OR (fol_date = '1982-08-13' AND fol_b_animid = 'ML') + OR (fol_date = '1984-02-08' AND fol_b_animid = 'FF') + OR (fol_date = '1984-05-27' AND fol_b_animid = 'GB') + OR (fol_date = '1984-05-28' AND fol_b_animid = 'GM') + OR (fol_date = '1984-06-06' AND fol_b_animid = 'ST') + OR (fol_date = '1984-08-28' AND fol_b_animid = 'GM') + OR (fol_date = '1986-03-20' AND fol_b_animid = 'FD') + OR (fol_date = '1987-09-19' AND fol_b_animid = 'PI') + OR (fol_date = '1988-07-21' AND fol_b_animid = 'ME') + OR (fol_date = '1988-09-06' AND fol_b_animid = 'GB') + OR (fol_date = '1989-01-09' AND fol_b_animid = 'AL') + OR (fol_date = '1993-04-01' AND fol_b_animid = 'PF') + OR (fol_date = '1995-05-19' AND fol_b_animid = 'TB') + OR (fol_date = '1998-07-13' AND fol_b_animid = 'WL') + OR (fol_date = '1998-09-28' AND fol_b_animid = 'SL') + OR (fol_date = '1999-01-03' AND fol_b_animid = 'FF') + OR (fol_date = '2012-08-27' AND fol_b_animid = 'KON') + OR (fol_date = '2014-10-27' AND fol_b_animid = 'WEM') + OR (fol_date = '2014-11-23' AND fol_b_animid = 'WEM') + OR (fol_date = '2014-12-23' AND fol_b_animid = 'EZA') + OR (fol_date = '2015-01-05' AND fol_b_animid = 'VAN') + OR (fol_date = '2015-01-17' AND fol_b_animid = 'SI'); ANALYZE follows -- 2.34.1